Setting Up Claude for Google Sheets

Build with Claude \ Anthropic

1. 1. Click on Start building

   

2. 2. Click on Get API keys

   

3. 3. Click on Create Key

   

4. 4. Type "Keysheets"

   

5. 5. Click on Add

   

6. 6. Click on Copy Key

   

7. 7. Install Claude's Add on

   

Google Docs

1. 8. Click on Extensions

   

2. 9. Click on Claude for Sheets™…

   

3. 10. Click on Settings

   

4. 11. Click on API provider

   

5. 12. Paste selected text into input

   

6. 13. Click on Default model

   

7. 14. Select Claude 3 Opus

   

8. 15. Click on Save

   

9. 16. Paste the data you want to classify and enter a system prompt with a Variable in {{....}}

   

10. 17. IN the Row prompt, substitute the variable

    

11. 18. Use =claude( Function to call the row prompt

    

12. 19. Drag throughout the whole sheet